package database.DatabaseHelpers;


public class CheckInConstants {

	public static final String TABLE_CHECKIN = "checkin";
	public static final String COLUMN_ID = "_id";
	public static final String COLUMN_LOCATION_ID = "locationid";
	public static final String COLUMN_DATE = "date";
	public static final String COLUMN_POINTS = "points";

	

	// Database creation sql statement
	public static final String DB_CREATE = "create table "
			+ TABLE_CHECKIN + "( " + COLUMN_ID
			+ " integer primary key autoincrement, "+ COLUMN_LOCATION_ID
			+ " integer not null, "  + COLUMN_DATE
			+ " text not null, " + COLUMN_POINTS
			+ " integer not null);";

	

}